Declaration:
#Reference, #Uses,
Attribute,
Class Module, Code
Module, Const,
Declare, Deftype,
Dim, Enum...End
Enum, Function...End
Function, Object Module,
Option, Private,
Property...End
Property, Public,
ReDim, Static,
Sub...End Sub,
Type...End
Type. WithEvents
Data Type:
Any, Boolean,
Byte, Currency,
Date, Decimal,
Double, Integer,
Long, Object,
PortInt, Single,
String, String*n,
Variant, obj
type, user
enum, user
type.
Assignment:
Erase, Let,
LSet, RSet,
Set.
Flow Control:
Call, CallByName,
Do...Loop, End,
Exit, For...Next,
For Each...Next,
GoTo, If...ElseIf...Else...End
If, MacroRun,
MacroRunThis,
Select
Case...End Select, Stop,
While...Wend.
Error Handling:
Err, Error,
On Error,
Resume.
Conversion:
Array, CBool,
CByte, CCur,
CDate, CDec,
CDbl, CInt,
CLng, CSng,
CStr, CVar,
CVDate, CVErr,
Val.
Variable Info:
IsArray, IsDate,
IsEmpty, IsError,
IsMissing, IsNull,
IsNumeric, IsObject,
LBound, TypeName,
UBound, VarType.
Constant:
Empty, False,
Nothing, Null,
True, Win16, Win32.
Math:
Abs, Atn,
Cos, Exp,
Fix, Int,
Log, Randomize,
Rnd, Round,
Sgn, Sin,
Sqr, Tan.
String:
Asc, AscB,
AscW, Chr,
ChrB, ChrW,
Format, Hex,
InStr, InStrB,
InStrRev, Join,
LCase, Left,
LeftB, Len,
LenB, LTrim,
Mid, MidB,
Oct, Replace,
Right, RightB,
RTrim, Space,
Split, String,
Str, StrComp,
StrConv, StrReverse,
Trim, UCase.
Object:
CreateObject,
GetObject, Me,
With...End With.
Time/Date:
Date, DateAdd,
DateDiff, DatePart,
DateSerial,
DateValue, Day,
Hour, Minute,
Month, MonthName,
Now, Second,
Time, Timer,
TimeSerial,
TimeValue, Weekday,
WeekdayName,
Year.
File:
ChDir, ChDrive,
Close, CurDir,
Dir, EOF,
FileAttr, FileCopy,
FileDateTime,
FileLen, FreeFile,
Get, GetAttr,
Input, Input,
Kill, Line
Input, Loc, Lock,
LOF, MkDir,
Name, Open,
Print, Put,
Reset, RmDir,
Seek, Seek,
SetAttr,
Unlock, Write.
User Input:
Dialog,
GetFilePath,
InputBox, MsgBox.
ShowPopupMenu
User Dialog:
Begin
Dialog...End Dialog, CancelButton,
CheckBox,
ComboBox,
DropListBox,
GroupBox,
ListBox,
OKButton,
OptionButton,
OptionGroup,
Picture,
PushButton,
Text,
TextBox.
Dialog Function:
Dialog Func, DlgControlId,
DlgCount, DlgEnable,
DlgEnd, DlgFocus,
DlgListBoxArray,
DlgName, DlgNumber,
DlgSetPicture,
DlgText,
DlgType, DlgValue,
DlgVisible.
DDE:
DDEExecute,
DDEInitiate,
DDEPoke,
DDERequest,
DDETerminate,
DDETerminateAll.
Settings:
DeleteSetting,
GetAllSettings,
GetSetting,
SaveSetting
Miscellaneous:
AppActivate,
Attribute,
Beep, CallersLine,
Choose, Clipboard,
Command, Debug.Print,
DoEvents,
Environ, Eval,
IIf, KeyName,
MacroDir, QBColor,
Rem, RGB,
SendKeys,
Shell, Wait.
Operator:
Operators: +, -, ^,
*, /, \, Mod, +, -, &, =, <>, <, >, <=, >=, Like.
Not, And, Or, Xor, Eqv, Imp, Is.
See Also: